[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '7' >
8 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109 | 14.4231 | 1973-05-26 | Marketing | mary0@adventure-works.com | Mary Gibson | 531-555-0183 | 767955365 | Mary | F | 2019-09-25 | Gibson | adventure-works\mary0 | M | E | 7 | 2 | 531-555-0183 | | 43 | 2019-09-25 | Current | Marketing Specialist | 46 |
| 122 | 14.4231 | 1990-02-28 | Marketing | jill0@adventure-works.com | Jill Williams | 510-555-0121 | 72636981 | Jill | F | 2019-10-01 | Williams | adventure-works\jill0 | M | A | 7 | 2 | 510-555-0121 | | 43 | 2019-10-01 | Current | Marketing Specialist | 47 |
| 273 | 13.4615 | 1985-11-27 | Marketing | wanida0@adventure-works.com | Wanida Benshoof | 708-555-0141 | 323403273 | Wanida | F | 2021-09-19 | Benshoof | adventure-works\wanida0 | M | M | 7 | 2 | 708-555-0141 | | 40 | 2021-09-19 | Current | Marketing Assistant | 41 |
| 275 | 14.4231 | 1988-11-16 | Marketing | john5@adventure-works.com | John Wood | 486-555-0150 | 222969461 | John | M | 2021-10-20 | Wood | adventure-works\john5 | S | L | 7 | 2 | 486-555-0150 | | 44 | 2021-10-20 | Current | Marketing Specialist | 48 |
| 276 | 13.4615 | 1988-10-11 | Marketing | mary2@adventure-works.com | Mary Dempsey | 124-555-0114 | 52541318 | Mary | F | 2021-10-27 | Dempsey | adventure-works\mary2 | S | A | 7 | 2 | 124-555-0114 | | 41 | 2021-10-27 | Current | Marketing Assistant | 43 |
| 2 | 13.4615 | 1998-01-13 | Marketing | kevin0@adventure-works.com | Kevin Brown | 150-555-0189 | 253022876 | Kevin | M | 2017-10-08 | Brown | adventure-works\kevin0 | S | F | 7 | 2 | 150-555-0189 | | 41 | 2017-10-08 | Current | Marketing Assistant | 42 |
| 207 | 14.4231 | 1996-10-17 | Marketing | terry0@adventure-works.com | Terry Eminhizer | 138-555-0118 | 243322160 | Terry | M | 2019-11-13 | Eminhizer | adventure-works\terry0 | M | J | 7 | 2 | 138-555-0118 | | 42 | 2019-11-13 | Current | Marketing Specialist | 44 |
| 48 | 14.4231 | 1998-01-31 | Marketing | sariya0@adventure-works.com | Sariya Harnpadoungsataya | 399-555-0176 | 95958330 | Sariya | M | 2019-08-25 | Harnpadoungsataya | adventure-works\sariya0 | S | E | 7 | 2 | 399-555-0176 | | 42 | 2019-08-25 | Current | Marketing Specialist | 45 |
Generated 2025-03-13 04:01:02.658 UTC